Oracle Data Service Integrator Documentation > Data Services Developer's Guide

Create First Data Services Cheatsheet

If you'd like to create your first data services in less than 15 minutes, follow these abbreviated steps:

1. Create a new dataspace project called:

   myDataspace

   

   
   

2. Under it create folders named logical and physical
   
   Under physical:
   

   New > Physical Data Service

   
   
3. Choose Relational
4. Select dspSampesDataSource as the data source.
5. Select RTLAPPLOMS and RTLCUSTOMER
6. Next.
   
7. Mark all operations
   

   Public

   Next

8. Set common Namespace to:

   custOrdersItems

   Next

9. Finish
10. No to the question about opening all the new data services.
11. Click the logical folder

    New > Logical Data Service

12. Call the data service:

    CUST_ORDERS_ITEMS

13. Click Finish.
14. Add an operation and name it: custOrdersItemsByCustID
15. Click OK.
16. {{Click on the name of the new operation to enter the Query Map.
    }}
17. Drag the Read operations from the following to the work area:

• CUSTOMER.ds
• CUSTOMER_ORDER.ds
• CUSTOMER_ORDER_LINE_ITEM.ds

1. Edit the signature to Add a string parameter named:

   last_name

2. Click OK twice.
3. Click Overwrite mode.
4. Drag, then expand in the following order: 

• CUSTOMER*
• CUSTOMER_ORDER*
• CUSTOMER_ORDER_LINE_ITEM*

1. Map the Zone icons to the respective element in the Return type: 

• CUSTOMER_ORDER*
• CUSTOMER_ORDER_LINE_ITEM*

1. Create the following joins:

   Source and element	Target and element
   $CUSTOMER/CUSTOMER_ID	$CUSTOMER_ORDER/C_ID
   $CUSTOMER_ORDER/ORDER_ID	$CUSTOMER_ORDER_LINE_ITEM/ORDER_ID

2. Associate the custID parameter with the CUSTOMER/CUSTOMER_ID element.
3. From the Return type, Save and Associate XML type.
4. Change the CUSTOMER name to {CUST_ORDERS_ITEMS}}.
   1. Modify your new CUST_ORDERS_ITEMS XML Type:
   2. Click on the Overview tab, if it is not already selected.
   3. Right-click on the topmost element in the XML type: CUST_ORDER_ITEMS.
   4. Select Edit Schema. The Eclipse schema editor opens.
   5. Click the schema editor's Source tab (below the editor's work area).
   6. Locate the first qualified element: CUSTOMER_ORDER.
   7. Place your cursor where you want to add the statement (just before the closing angle bracket at the end of the line)
   8. Enter a space.
   9. Activate the code assistant with the combination:

      Ctrl + spacebar

      You will get a code completion dialog.

5. Perform the Ctrl+space operation twice, once for the max_occurs, and again to add the unbounded statement. The line now appears as:

   F I X

6. Follow Steps 5-9 for the second qualified element, CUSTOMER_ORDER_LINE_ITEM.
7. Save the CUST_ORDERS_ITEMS.xsd file.
   

   File > Save